Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
OBJ VARCHAR2(20) No null 1 null NO NO NO
ID VARCHAR2(100) Yes null 2 null NO NO NO
TITLE VARCHAR2(400) Yes null 3 null NO NO NO
ACTIVITY_TYPE VARCHAR2(100) No null 4 null NO NO NO
ACTIVITY_DATE DATE Yes null 5 null NO NO NO
ACTIVITY_DATE_FY NUMBER Yes null 6 null NO NO NO
CREATED_ON DATE Yes null 7 null NO NO NO
CREATED_ON_FY NUMBER Yes null 8 null NO NO NO
STATUS VARCHAR2(100) Yes null 9 null NO NO NO
CLOSED_ON DATE Yes null 10 null NO NO NO
CLOSED_ON_FY NUMBER Yes null 11 null NO NO NO
DAYS_OPEN NUMBER Yes null 12 null NO NO NO
OWNING_UNIT VARCHAR2(400) Yes null 13 null NO NO NO
LEAD VARCHAR2(400) Yes null 14 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(4000) Yes null 15 null NO NO NO
ASSOCIATIONS_COUNT NUMBER Yes null 16 null NO NO NO
ATTACHMENTS_COUNT NUMBER Yes null 17 null NO NO NO
NOTES_COUNT NUMBER Yes null 18 null NO NO NO
NEXT_DUE_DATE DATE Yes null 19 null NO NO NO
FINAL_DUE_DATE DATE Yes null 20 null NO NO NO
FINAL_DUE_DATE_FY NUMBER Yes null 21 null NO NO NO
FINAL_DUE_DATE_MET VARCHAR2(3) Yes null 22 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 06-APR-23
LAST_DDL_TIME 24-OCT-24
OWNER QART
VIEW_NAME V_CUBE_ALL_ACTIVITIES
TEXT_LENGTH 2523
TEXT SELECT O.SID AS OBJ,           O.ID,           O.TAGLINE AS TITLE,           T.DISPLAY AS ACTIVITY_TYPE,           A.ACTIVITY_DATE,           A.ACTIVITY_DATE_FY,           O.CREATED_ON,           O.CREATED_ON_FY,           H.STATUS,           CASE              WHEN H.CODE = 'CLOSED' THEN                 H.STARTED_ON              ELSE                 NULL           END AS CLOSED_ON,           CASE              WHEN H.CODE = 'CLOSED' THEN                 H.STARTED_ON_FY              ELSE                 NULL           END AS CLOSED_ON_FY,           CASE              WHEN H.STATUS = 'Closed' THEN                 ( TRUNC(H.STARTED_ON) - TRUNC(O.CREATED_ON) )              ELSE                 ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) )           END DAYS_OPEN,           SH_OU.SH_DISPLAY AS OWNING_UNIT,           SH_LEAD.SH_DISPLAY AS LEAD,           SH_SUPP.SH_DISPLAY AS SUPPORT_PERSONNEL,           ( SELECT COUNT(1)                 FROM MV_ACM_ASSOCIATION              WHERE FROM_OBJ = O.SID                 OR TO_OBJ = O.SID           ) AS ASSOCIATIONS_COUNT,           ( SELECT COUNT(1)                 FROM MV_ACM_ATTACHMENT              WHERE OBJ = O.SID           ) AS ATTACHMENTS_COUNT,           ( SELECT COUNT(1)                 FROM MV_ACM_NOTE              WHERE OBJ = O.SID           ) AS NOTES_COUNT,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN H.STATUS = 'Closed'                 AND TRUNC(H.STARTED_ON) <= TRUNC(O.FINAL_DUE_DATE) THEN                 'Yes'              ELSE                 'No'           END FINAL_DUE_DATE_MET      FROM MV_ACM_OBJ O     INNER JOIN MV_ACM_OBJ_TYPE T ON O.OBJ_TYPE = T.SID and t.active = 'Y'       AND T.OBJ_ROOT = 'ACT'      LEFT JOIN V_ALL_ACTIVITIES A ON O.SID = A.OBJ      LEFT JOIN V_OBJ_STATUS_HISTORY H ON O.SID = H.OBJ       AND H.COMPLETED_ON IS NULL      LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH_OU ON O.SID = SH_OU.OBJ       AND SH_OU.CODE = 'OWNING_UNIT'      LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH_LEAD ON O.SID = SH_LEAD.OBJ       AND SH_LEAD.CODE = 'LEAD'      LEFT JOIN ( SELECT DISTINCT OBJ,                                  LISTAGG(SH_DISPLAY,                                          ';' || CHR(13)) WITHIN GROUP(                                   ORDER BY SH_DISPLAY)                                  OVER(PARTITION BY OBJ) SH_DISPLAY                              FROM V_CURR_OBJ_STAKEHOLDERS                 WHERE CODE = 'SUPPORT'                ) SH_SUPP ON O.SID = SH_SUPP.OBJ
TEXT_VC SELECT O.SID AS OBJ,           O.ID,           O.TAGLINE AS TITLE,           T.DISPLAY AS ACTIVITY_TYPE,           A.ACTIVITY_DATE,           A.ACTIVITY_DATE_FY,           O.CREATED_ON,           O.CREATED_ON_FY,           H.STATUS,           CASE              WHEN H.CODE = 'CLOSED' THEN                 H.STARTED_ON              ELSE                 NULL           END AS CLOSED_ON,           CASE              WHEN H.CODE = 'CLOSED' THEN                 H.STARTED_ON_FY              ELSE                 NULL           END AS CLOSED_ON_FY,           CASE              WHEN H.STATUS = 'Closed' THEN                 ( TRUNC(H.STARTED_ON) - TRUNC(O.CREATED_ON) )              ELSE                 ( TRUNC(SYSDATE) - TRUNC(O.CREATED_ON) )           END DAYS_OPEN,           SH_OU.SH_DISPLAY AS OWNING_UNIT,           SH_LEAD.SH_DISPLAY AS LEAD,           SH_SUPP.SH_DISPLAY AS SUPPORT_PERSONNEL,           ( SELECT COUNT(1)                 FROM MV_ACM_ASSOCIATION              WHERE FROM_OBJ = O.SID                 OR TO_OBJ = O.SID           ) AS ASSOCIATIONS_COUNT,           ( SELECT COUNT(1)                 FROM MV_ACM_ATTACHMENT              WHERE OBJ = O.SID           ) AS ATTACHMENTS_COUNT,           ( SELECT COUNT(1)                 FROM MV_ACM_NOTE              WHERE OBJ = O.SID           ) AS NOTES_COUNT,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN H.STATUS = 'Closed'                 AND TRUNC(H.STARTED_ON) <= TRUNC(O.FINAL_DUE_DATE) THEN                 'Yes'              ELSE                 'No'           END FINAL_DUE_DATE_MET      FROM MV_ACM_OBJ O     INNER JOIN MV_ACM_OBJ_TYPE T ON O.OBJ_TYPE = T.SID and t.active = 'Y'       AND T.OBJ_ROOT = 'ACT'      LEFT JOIN V_ALL_ACTIVITIES A ON O.SID = A.OBJ      LEFT JOIN V_OBJ_STATUS_HISTORY H ON O.SID = H.OBJ       AND H.COMPLETED_ON IS NULL      LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH_OU ON O.SID = SH_OU.OBJ       AND SH_OU.CODE = 'OWNING_UNIT'      LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH_LEAD ON O.SID = SH_LEAD.OBJ       AND SH_LEAD.CODE = 'LEAD'      LEFT JOIN ( SELECT DISTINCT OBJ,                                  LISTAGG(SH_DISPLAY,                                          ';' || CHR(13)) WITHIN GROUP(                                   ORDER BY SH_DISPLAY)                                  OVER(PARTITION BY OBJ) SH_DISPLAY                              FROM V_CURR_OBJ_STAKEHOLDERS                 WHERE CODE = 'SUPPORT'                ) SH_SUPP ON O.SID = SH_SUPP.OBJ
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT